package com.wframe.project.former.dataservices.floor;

import com.frame.database.JBaseDao;
import com.frame.database.JdataBean;

import java.util.List;

/**
 * Created by Administrator on 2017/5/26.
 */
public class UiFloorPanelDao extends JBaseDao {
    public UiFloorPanelDao() {
        super("ui_floor_panel");
    }

    public void updateUifloorPanelState(String uifroolpenleid,String state) throws Exception{
        getSession().update("update ui_floor_panel set state=? where id=?",new Object[]{state,uifroolpenleid});
    }
        public List<JdataBean> queryPanel(String ui_floor_id) throws Exception{
        return getSession().query("select * from ui_floor_panel where ui_floor_id=? and state='AVAILABLE' or state='UNAVAILABLE' order by sort_value desc", new Object[]{ui_floor_id});
    }
}
